To format data for import
The transaction format is tab- or comma-delimited input, with various types of records allowed in a single stream. The import file must contain a single batch header record, followed by any number of cash payment records. There should not be any empty lines between record entries.
Note: You can use the AR Importer for accrual dues billing.
The major transaction formats include the following:
All records
# |
Field Name |
Data |
Comments |
1 |
Record Type |
|
Identifies the type of record |
2 |
Batch Number |
10 chars, all upper case |
|
Batch header
# |
Field Name |
Data |
Comments |
1 |
Record Type |
BH |
Always "BH" |
2 |
Batch Number |
10 chars, all upper case |
|
3 |
Batch Date |
Date |
Date of batch (mm/dd/yy) |
4 |
Batch Description |
60 chars |
|
5 |
Control Count |
Numeric |
Optional |
6 |
Control Amount |
Monetary |
Total of the batch of payments |
7 |
Cash Account Code |
10 chars, all upper case |
Code assigned through the Set up cash accounts window. Indicates the cash account into which the funds were deposited. |
Cash payment record
# |
Field Name |
Data |
Comments |
1 |
Record Type |
PAY |
Always "PAY" |
2 |
Batch Number |
10 chars, all upper case |
Optional. If blank, defaults to batch header's batch number. |
3 |
System |
AR |
|
4 |
Customer ID |
10 chars, customer ID |
Can substitute with Major Key, if prefixed with * (asterisk) |
5 |
Date |
Date |
Optional. If blank, defaults to batch header date. |
6 |
Invoice |
Alphanumeric |
The invoice number. This field is required if the Auto Apply option is not enabled in the AR/Cash Set up module window. |
7 |
Amount |
Individual payment amount |
Total amount of the check or credit card payment. Do not enter a $ (dollar sign). |
8 |
Check/CCType |
Check number or credit card type |
Optional |
9 |
CCNumber |
Credit card number |
Optional |
10 |
CCExp |
Credit card expiriation date |
Optional |
11 |
Name on CC |
Name on credit card |
Optional |
12 |
CCAuthorize |
Credit card authorization code |
Optional |
13 |
Name |
60 chars for audit trail |
Optional but important. This value is printed on the transaction report to identify the customer. |
14 |
Comment |
255 chars |
Optional but important. This value is printed on the transaction report and related inquiries to explain the transaction, such as "Dues Payment" or "Subscription Payment". |
10.6 Production Release. Updated 10/5/2005 3:10:20 PM
© 2009 by Advanced Solutions International, Inc.
All rights reserved.